<?php
/***************************************************************************
*                            Dolphin Smart Community Builder
*                              -------------------
*     begin                : Mon Mar 23 2006
*     copyright            : (C) 2007 BoonEx Group
*     website              : http://www.boonex.com
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software; you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the
* License, or  any later version.
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU General Public License for more details.
* You should have received a copy of the GNU General Public License along with Dolphin,
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/

require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolModuleDb.php' );

define('BX_QUOTES_TABLE', 'bx_quotes_units');

/*
* Quotes module Data
*/
class BxQuotesDb extends BxDolModuleDb {	
	var $_oConfig;
	/*
	* Constructor.
	*/
	function BxQuotesDb(&$oConfig) {
		parent::BxDolModuleDb();

		$this->_oConfig = $oConfig;
	}

	function getRandomQuote() {
		return $this->getRow("SELECT `Text`, `Author` FROM `" . BX_QUOTES_TABLE . "` ORDER BY RAND() LIMIT 1");
	}
	function getQuote($iID) {
		return $this->getRow("SELECT * FROM `" . BX_QUOTES_TABLE . "` WHERE `ID`='{$iID}' LIMIT 1");
	}
	function getAllQuotes() {
		return $this->getAll("SELECT * FROM `" . BX_QUOTES_TABLE . "`");
	}
    function deleteUnit($iID) {
        return $this->query("DELETE FROM `" . BX_QUOTES_TABLE . "` WHERE `ID`='{$iID}' LIMIT 1");
    }
}

?>